# coding: utf-8
from . import db, BaseModel


class File(db.Model):
    __tablename__ = 'file'

    auto_id = db.Column(db.Integer, primary_key=True)
    file_id = db.Column(db.BigInteger, index=True, info='报告编号')
    experiment_id = db.Column(db.BigInteger, info='实验编号')
    student_id = db.Column(db.BigInteger, info='学生编号')
    file = db.Column(db.LargeBinary, info='实验报告')
    is_delete = db.Column(db.Integer, server_default=db.FetchedValue())
    update_time = db.Column(db.DateTime, server_default=db.FetchedValue())
    create_time = db.Column(db.DateTime, server_default=db.FetchedValue())
